/******************************************************************************
	This file is a part of the Snapshot Bioinformatics Project

	Copyright (C) 2012-2013 Jarom Schow

	This program is free software: you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation, either version 3 of the License, or
	(at your option) any later version.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program.  If not, see <http://www.gnu.org/licenses/>.
******************************************************************************/
#ifndef DB_XREF_INSERT_BUILDER_H
#define DB_XREF_INSERT_BUILDER_H

#include <QtCore/QSet>

#include "SqlInsertBuilder.h"

namespace Bio {

class SqlServer;

class BIO_EXPORT DbXrefInsertBuilder  {
public:
	DbXrefInsertBuilder( SqlServer *server );
	virtual ~DbXrefInsertBuilder();

	int		getDbXRefId( const QString &db, const QString &accession, int version = 1 );

	bool	getBioentryDbXRef( int bioId, int dbXRefId, int rank );
	bool	getSeqFeatureDbXRef( int seqFeatureId, int dbXRefId, int rank );

	bool	flush();

private:

	int	m_dbXRefIdx;

	SqlServer			*m_server;
	QHash<QString, int>	m_dbXRefs;
	QSet<qint64>		m_bioentryRefs, m_seqFeatureRefs;

	int			m_dbXRefSize, m_bioentrySize, m_seqFeatureSize;
	QStringList	m_dbXRefValues, m_bioentryValues, m_seqFeatureValues;
};

}; // Bio

#endif // DB_XREF_INSERT_BUILDER_H